2015-11-18 - 21505.100 - Release Notes - Futures report - Release 003 #2015BIReleaseNotes

Release Notes:

21505.100 - Futures report

Admin Info

Purpose
 Need to rebuild the old SA410 report to review data.
Release No
 001
Submitted
 11/18/2015
Submitted by
 Uday Kumar P
Source/Destination Systems
 BOBJ 4.1 Dev to BOBJ 4.1 Prod
Release Sent To
 Mark Harris
Object(s) Created By
 Venkateswara Reddy D
Object(s) Tested By
 Venkateswara Reddy D

Report Name

SA410 - Futures by Sales Org, SBU and Major Season.

Name of the BEx Querie(s)

ZSD_ORDER_Q001

NEC Crystal Reports Standards Check

SA410 has been successfully checked against the NEC Crystal Reports Standards Checklist attached here:
SA410 Checklist.xlsx

Summary Level Check

Test Conducted

Parameter : 1 - ALL
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 3,026,992
 3,026,992
 Pass
2
 2015 AMT
 27,543,643
 27,543,643.23
 Pass
3
 2014 QTY
 3,919,588
 3,919,588
 Pass
4
 2014 AMT
 37,746,342
 37,746,342.05
 Pass
5
 VAR QTY
 892,596
 NA
 Pass
6
 VAR AMT
 10,202,699
 NA
 Pass
7
 VAR % QTY
 129
 NA
 Pass
8
 VAR % AMT
 137
 NA
 Pass
Parameter : 2 - North America
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 1,948,946
 1,948,946
 Pass
2
 2015 AMT
 17,050,353
 17,050,353.19
 Pass
3
 2014 QTY
 2,929,718
 2,929,718
 Pass
4
 2014 AMT
 26,430,080
 26,430,080.35
 Pass
5
 VAR QTY
 980,772
 NA
 Pass
6
 VAR AMT
 9,379,727
 NA
 Pass
7
 VAR % QTY
 150
 NA
 Pass
8
 VAR % AMT
 155
 NA
 Pass
Parameter : 3 - Emerging Markets
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 165,140
 165,140
 Pass
2
 2015 AMT
 2,386,452
 2,386,452.23
 Pass
3
 2014 QTY
 160,727
 160,727
 Pass
4
 2014 AMT
 2,036,800
 2,036,799.68
 Pass
5
 VAR QTY
 -4,413
 NA
 Pass
6
 VAR AMT
 -349,653
 NA
 Pass
7
 VAR % QTY
 97
 NA
 Pass
8
 VAR % AMT
 85
 NA
 Pass
Parameter : 4 - EMEA
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 866,445
 866,445
 Pass
2
 2015 AMT
 7,106,611
 7,106,610.44
 Pass
3
 2014 QTY
 664,697
 664,697
 Pass
4
 2014 AMT
 6,343,448
 6,343,447.83
 Pass
5
 VAR QTY
 -201,748
 NA
 Pass
6
 VAR AMT
 -763,163
 NA
 Pass
7
 VAR % QTY
 77
 NA
 Pass
8
 VAR % AMT
 89
 NA
 Pass
Parameter : 5 - Japan
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 46,461
 46,461
 Pass
2
 2015 AMT
 1,000,227
 1,000,227.37
 Pass
3
 2014 QTY
 164,446
 164,446
 Pass
4
 2014 AMT
 2,936,014
 2,936,014.19
 Pass
5
 VAR QTY
 117,985
 NA
 Pass
6
 VAR AMT
 1,935,787
 NA
 Pass
7
 VAR % QTY
 354
 NA
 Pass
8
 VAR % AMT
 294
 NA
 Pass

Secondary Level Check

Test Conducted

Grouping: North America >5th & Ocean Sales
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 3,591
 3,591
 Pass
2
 2015 AMT
 34,662
 34,661.85
 Pass
3
 2014 QTY
 514,023
 514,023
 Pass
4
 2014 AMT
 5,507,823
 5,507,822.89
 Pass
5
 VAR QTY
 510,432
 NA
 Pass
6
 VAR AMT
 5,473,161
 NA
 Pass
7
 VAR % QTY
 14,314
 NA
 Pass
8
 VAR % AMT
 15,890
 NA
 Pass
Grouping: North America >5th & Ocean Sales > VS Apparel
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 NA
 NA
 Pass
2
 2015 AMT
 NA
 NA
 Pass
3
 2014 QTY
 407,997
 407,997
 Pass
4
 2014 AMT
 4,331,460
 4,331,460.45
 Pass
5
 VAR QTY
 407,997
 NA
 Pass
6
 VAR AMT
 4,331,460
 NA
 Pass
7
 VAR % QTY
 100
 NA
 Pass
8
 VAR % AMT
 100
 NA
 Pass
Grouping: North America >5th & Ocean Sales > VS Apparel >Others
SNo
 Test Case
 Value in Production Report
 Value in Source Report
 Pass/Fail
1
 2015 QTY
 NA
 NA
 Pass
2
 2015 AMT
 NA
 NA
 Pass
3
 2014 QTY
 407,997
 407,997
 Pass
4
 2014 AMT
 4,331,460
 4,331,460.45
 Pass
5
 VAR QTY
 407,997
 NA
 Pass
6
 VAR AMT
 4,331,460
 NA
 Pass
7
 VAR % QTY
 100
 NA
 Pass
8
 VAR % AMT
 100
 NA
 Pass

Reference Document (Specification)
2015-08-26 - 21505.100 - Spec - Futures report - (Mark H by 2015-09-04)